Filename: customer rates.csv
This file describes which rates a customer currently is being billed for, the price they are paying and how often they are billed. Any rates referenced in this file must have been defined in the Rates Format file.
This has the following columns:
| Column Name | Description |
|---|---|
| rate | the matching name of the rate desired for the currently submitted subscriber in the rates file |
| customer_original_id | the unique id for the matching record in the customer file. Multiple entries for the same customer are accepted and all signify that a customer has signed up for more than 1 rate |
| billing_period | How often the customer is billed or this rate, in months |
| billing_start_date | This is the date for our billing system to begin billing the customer for this rateIn the format of MM/DD/YYYY. |
| price_override (optional) | The recurring Fixed price you want the rate to use instead of the default price. This is a number/decimal number i.e. “11” or “12.34” (without quotes) are Fine. If the default price specified in the rates file should be used this should be blank |
| original_id | Optional. If this is not needed this column can be omitted. This is to uniquely identify this instance of the customer’s rate later in the import when services are defined. If a customer has multiples of the same rate this allows a services to be associated to this specific instance. If this is unused, and a customer has multiple of the same rate any services added under this same customer rate name will be added to the first instance of the cutomer’s rate by that name. The value for the original_id can be any combination of both letters and numbers. |